SELECT c.video_id FROM videos_categories c INNER JOIN videos_tags t1 ON t1.video_id=c.video_id AND t1.tag_id=85 INNER JOIN videos_tags t2 ON t2.video_id=c.video_id AND t2.tag_id=1 INNER JOIN videos_tags t3 ON t3.video_id=c.video_id AND t3.tag_id=35 WHERE c.category_id=? ORDER BY c.sort_relevant,c.video_id LIMIT 0,24